﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="nrDataSet" targetNamespace="http://tempuri.org/nrDataSet.xsd" xmlns:mstns="http://tempuri.org/nrDataSet.xsd" xmlns="http://tempuri.org/nrDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="nrConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="nrConnectionString (Settings)" PropertyReference="ApplicationSettings.nr.GLV.Data.Properties.Settings.GlobalReference.Default.nrConnectionString" Provider="System.Data.OleDb" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CitiesTableAdapter" GeneratorDataComponentClassName="CitiesTableAdapter" Name="Cities" UserDataComponentName="CitiesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="nrConnectionString (Settings)" DbObjectName="Cities" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Cities` WHERE (((? = 1 AND `CityISTATCode` IS NULL) OR (`CityISTATCode` = ?)) AND ((? = 1 AND `CityName` IS NULL) OR (`CityName` = ?)) AND ((? = 1 AND `CityDistrict` IS NULL) OR (`CityDistrict` = ?)) AND ((? = 1 AND `CityRegion` IS NULL) OR (`CityRegion` = ?)) AND ((? = 1 AND `CityPhoneAreaCode` IS NULL) OR (`CityPhoneAreaCode` = ?)) AND ((? = 1 AND `CityZIP` IS NULL) OR (`CityZIP` = ?)) AND ((? = 1 AND `CityFiscalCode` IS NULL) OR (`CityFiscalCode` = ?)) AND ((? = 1 AND `CityPeoples` IS NULL) OR (`CityPeoples` = ?)) AND (`CityID` = ?) AND ((? = 1 AND `CityState` IS NULL) OR (`CityState` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CityISTATCode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityISTATCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_CityISTATCode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityISTATCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CityName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CityName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CityName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CityDistrict" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityDistrict" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CityDistrict" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CityDistrict" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CityRegion" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityRegion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CityRegion" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CityRegion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CityPhoneAreaCode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityPhoneAreaCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CityPhoneAreaCode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CityPhoneAreaCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CityZIP" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityZIP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CityZIP" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CityZIP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CityFiscalCode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityFiscalCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CityFiscalCode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CityFiscalCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CityPeoples" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityPeoples" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_CityPeoples" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityPeoples" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_CityID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CityState" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityState" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_CityState" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityState" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Cities` (`CityISTATCode`, `CityName`, `CityDistrict`, `CityRegion`, `CityPhoneAreaCode`, `CityZIP`, `CityFiscalCode`, `CityPeoples`, `CityLink`, `CityState`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="CityISTATCode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityISTATCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CityName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CityName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CityDistrict" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CityDistrict" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CityRegion" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CityRegion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CityPhoneAreaCode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CityPhoneAreaCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CityZIP" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CityZIP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CityFiscalCode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CityFiscalCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="CityPeoples" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityPeoples" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CityLink" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="CityLink" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="CityState" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityState" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CityISTATCode, CityName, CityDistrict, CityRegion, CityPhoneAreaCode, CityZIP, CityFiscalCode, CityPeoples, CityLink, CityID, CityState FROM Cities</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Cities` SET `CityISTATCode` = ?, `CityName` = ?, `CityDistrict` = ?, `CityRegion` = ?, `CityPhoneAreaCode` = ?, `CityZIP` = ?, `CityFiscalCode` = ?, `CityPeoples` = ?, `CityLink` = ?, `CityState` = ? WHERE (((? = 1 AND `CityISTATCode` IS NULL) OR (`CityISTATCode` = ?)) AND ((? = 1 AND `CityName` IS NULL) OR (`CityName` = ?)) AND ((? = 1 AND `CityDistrict` IS NULL) OR (`CityDistrict` = ?)) AND ((? = 1 AND `CityRegion` IS NULL) OR (`CityRegion` = ?)) AND ((? = 1 AND `CityPhoneAreaCode` IS NULL) OR (`CityPhoneAreaCode` = ?)) AND ((? = 1 AND `CityZIP` IS NULL) OR (`CityZIP` = ?)) AND ((? = 1 AND `CityFiscalCode` IS NULL) OR (`CityFiscalCode` = ?)) AND ((? = 1 AND `CityPeoples` IS NULL) OR (`CityPeoples` = ?)) AND (`CityID` = ?) AND ((? = 1 AND `CityState` IS NULL) OR (`CityState` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="CityISTATCode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityISTATCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CityName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CityName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CityDistrict" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CityDistrict" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CityRegion" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CityRegion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CityPhoneAreaCode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CityPhoneAreaCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CityZIP" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CityZIP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CityFiscalCode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CityFiscalCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="CityPeoples" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityPeoples" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CityLink" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="CityLink" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="CityState" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityState" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CityISTATCode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityISTATCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_CityISTATCode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityISTATCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CityName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CityName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CityName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CityDistrict" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityDistrict" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CityDistrict" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CityDistrict" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CityRegion" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityRegion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CityRegion" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CityRegion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CityPhoneAreaCode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityPhoneAreaCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CityPhoneAreaCode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CityPhoneAreaCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CityZIP" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityZIP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CityZIP" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CityZIP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CityFiscalCode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityFiscalCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CityFiscalCode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CityFiscalCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CityPeoples" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityPeoples" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_CityPeoples" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityPeoples" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_CityID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CityState" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityState" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_CityState" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CityState" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CityISTATCode" DataSetColumn="ISTATCode" />
              <Mapping SourceColumn="CityName" DataSetColumn="Name" />
              <Mapping SourceColumn="CityDistrict" DataSetColumn="District" />
              <Mapping SourceColumn="CityRegion" DataSetColumn="Region" />
              <Mapping SourceColumn="CityPhoneAreaCode" DataSetColumn="PhoneAreaCode" />
              <Mapping SourceColumn="CityZIP" DataSetColumn="ZIP" />
              <Mapping SourceColumn="CityFiscalCode" DataSetColumn="FiscalCode" />
              <Mapping SourceColumn="CityPeoples" DataSetColumn="Peoples" />
              <Mapping SourceColumn="CityLink" DataSetColumn="Link" />
              <Mapping SourceColumn="CityID" DataSetColumn="ID" />
              <Mapping SourceColumn="CityState" DataSetColumn="StateFK" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StatesTableAdapter" GeneratorDataComponentClassName="StatesTableAdapter" Name="States" UserDataComponentName="StatesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="nrConnectionString (Settings)" DbObjectName="States" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `States` WHERE (((? = 1 AND `StateName` IS NULL) OR (`StateName` = ?)) AND ((? = 1 AND `StateFiscalCode` IS NULL) OR (`StateFiscalCode` = ?)) AND ((? = 1 AND `StateIstatCode` IS NULL) OR (`StateIstatCode` = ?)) AND (`StateID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_StateName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="StateName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_StateName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="StateName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_StateFiscalCode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="StateFiscalCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_StateFiscalCode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="StateFiscalCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_StateIstatCode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="StateIstatCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_StateIstatCode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="StateIstatCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_StateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="StateID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `States` (`StateName`, `StateFiscalCode`, `StateIstatCode`) VALUES (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="StateName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="StateName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="StateFiscalCode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="StateFiscalCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="StateIstatCode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="StateIstatCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT StateName, StateFiscalCode, StateIstatCode, StateID FROM States</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `States` SET `StateName` = ?, `StateFiscalCode` = ?, `StateIstatCode` = ? WHERE (((? = 1 AND `StateName` IS NULL) OR (`StateName` = ?)) AND ((? = 1 AND `StateFiscalCode` IS NULL) OR (`StateFiscalCode` = ?)) AND ((? = 1 AND `StateIstatCode` IS NULL) OR (`StateIstatCode` = ?)) AND (`StateID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="StateName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="StateName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="StateFiscalCode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="StateFiscalCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="StateIstatCode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="StateIstatCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_StateName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="StateName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_StateName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="StateName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_StateFiscalCode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="StateFiscalCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_StateFiscalCode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="StateFiscalCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_StateIstatCode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="StateIstatCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_StateIstatCode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="StateIstatCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_StateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="StateID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="StateName" DataSetColumn="Name" />
              <Mapping SourceColumn="StateFiscalCode" DataSetColumn="FiscalCode" />
              <Mapping SourceColumn="StateIstatCode" DataSetColumn="ISTATCode" />
              <Mapping SourceColumn="StateID" DataSetColumn="ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CustomersTableAdapter" GeneratorDataComponentClassName="CustomersTableAdapter" Name="Customers" UserDataComponentName="CustomersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="nrConnectionString (Settings)" DbObjectName="Customers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Customers` WHERE ((`CustomerID` = ?) AND ((? = 1 AND `CustomerFirstName` IS NULL) OR (`CustomerFirstName` = ?)) AND ((? = 1 AND `CustomerLastName` IS NULL) OR (`CustomerLastName` = ?)) AND ((? = 1 AND `CustomerMainAddress` IS NULL) OR (`CustomerMainAddress` = ?)) AND ((? = 1 AND `CustomerMainCity` IS NULL) OR (`CustomerMainCity` = ?)) AND ((? = 1 AND `CustomerLamps` IS NULL) OR (`CustomerLamps` = ?)) AND ((? = 1 AND `CustomerLampPrice` IS NULL) OR (`CustomerLampPrice` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_CustomerID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CustomerFirstName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerFirstName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CustomerFirstName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerFirstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CustomerLastName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerLastName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CustomerLastName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerLastName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CustomerMainAddress" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerMainAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CustomerMainAddress" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerMainAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CustomerMainCity" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerMainCity" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_CustomerMainCity" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerMainCity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CustomerLamps" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerLamps" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_CustomerLamps" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="CustomerLamps" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CustomerLampPrice" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerLampPrice" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_CustomerLampPrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="CustomerLampPrice" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Customers` (`CustomerFirstName`, `CustomerLastName`, `CustomerMainAddress`, `CustomerMainCity`, `CustomerLamps`, `CustomerLampPrice`) VALUES (?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CustomerFirstName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerFirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CustomerLastName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerLastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CustomerMainAddress" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerMainAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="CustomerMainCity" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerMainCity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="CustomerLamps" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="CustomerLamps" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="CustomerLampPrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="CustomerLampPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CustomerID, CustomerFirstName, CustomerLastName, CustomerMainAddress, CustomerMainCity, CustomerLamps, CustomerLampPrice FROM Customers</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Customers` SET `CustomerFirstName` = ?, `CustomerLastName` = ?, `CustomerMainAddress` = ?, `CustomerMainCity` = ?, `CustomerLamps` = ?, `CustomerLampPrice` = ? WHERE ((`CustomerID` = ?) AND ((? = 1 AND `CustomerFirstName` IS NULL) OR (`CustomerFirstName` = ?)) AND ((? = 1 AND `CustomerLastName` IS NULL) OR (`CustomerLastName` = ?)) AND ((? = 1 AND `CustomerMainAddress` IS NULL) OR (`CustomerMainAddress` = ?)) AND ((? = 1 AND `CustomerMainCity` IS NULL) OR (`CustomerMainCity` = ?)) AND ((? = 1 AND `CustomerLamps` IS NULL) OR (`CustomerLamps` = ?)) AND ((? = 1 AND `CustomerLampPrice` IS NULL) OR (`CustomerLampPrice` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CustomerFirstName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerFirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CustomerLastName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerLastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CustomerMainAddress" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerMainAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="CustomerMainCity" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerMainCity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="CustomerLamps" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="CustomerLamps" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="CustomerLampPrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="CustomerLampPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_CustomerID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CustomerFirstName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerFirstName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CustomerFirstName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerFirstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CustomerLastName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerLastName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CustomerLastName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerLastName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CustomerMainAddress" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerMainAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CustomerMainAddress" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerMainAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CustomerMainCity" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerMainCity" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_CustomerMainCity" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerMainCity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CustomerLamps" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerLamps" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_CustomerLamps" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="CustomerLamps" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CustomerLampPrice" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerLampPrice" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_CustomerLampPrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="CustomerLampPrice" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CustomerID" DataSetColumn="ID" />
              <Mapping SourceColumn="CustomerFirstName" DataSetColumn="FirstName" />
              <Mapping SourceColumn="CustomerLastName" DataSetColumn="LastName" />
              <Mapping SourceColumn="CustomerMainAddress" DataSetColumn="MainAddress" />
              <Mapping SourceColumn="CustomerMainCity" DataSetColumn="MainCity" />
              <Mapping SourceColumn="CustomerLamps" DataSetColumn="Lamps" />
              <Mapping SourceColumn="CustomerLampPrice" DataSetColumn="LampPrice" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GravesTableAdapter" GeneratorDataComponentClassName="GravesTableAdapter" Name="Graves" UserDataComponentName="GravesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="nrConnectionString (Settings)" DbObjectName="Graves" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Graves` WHERE ((`GraveID` = ?) AND ((? = 1 AND `GraveFirstName` IS NULL) OR (`GraveFirstName` = ?)) AND ((? = 1 AND `GraveLastName` IS NULL) OR (`GraveLastName` = ?)) AND ((? = 1 AND `GraveBirthDate` IS NULL) OR (`GraveBirthDate` = ?)) AND ((? = 1 AND `GraveDeadDate` IS NULL) OR (`GraveDeadDate` = ?)) AND ((? = 1 AND `GravePosition` IS NULL) OR (`GravePosition` = ?)) AND ((? = 1 AND `GraveRow` IS NULL) OR (`GraveRow` = ?)) AND ((? = 1 AND `GraveFloor` IS NULL) OR (`GraveFloor` = ?)) AND ((? = 1 AND `GraveNumber` IS NULL) OR (`GraveNumber` = ?)) AND ((? = 1 AND `GraveCustomerFK` IS NULL) OR (`GraveCustomerFK` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_GraveID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GraveID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GraveFirstName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GraveFirstName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_GraveFirstName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GraveFirstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GraveLastName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GraveLastName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_GraveLastName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GraveLastName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GraveBirthDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GraveBirthDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_GraveBirthDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="GraveBirthDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GraveDeadDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GraveDeadDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_GraveDeadDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="GraveDeadDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GravePosition" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GravePosition" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_GravePosition" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GravePosition" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GraveRow" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GraveRow" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_GraveRow" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="GraveRow" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GraveFloor" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GraveFloor" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_GraveFloor" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="GraveFloor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GraveNumber" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GraveNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_GraveNumber" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="GraveNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GraveCustomerFK" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GraveCustomerFK" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_GraveCustomerFK" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GraveCustomerFK" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Graves` (`GraveFirstName`, `GraveLastName`, `GraveBirthDate`, `GraveDeadDate`, `GravePosition`, `GraveRow`, `GraveFloor`, `GraveNumber`, `GraveCustomerFK`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="GraveFirstName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GraveFirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="GraveLastName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GraveLastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="GraveBirthDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="GraveBirthDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="GraveDeadDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="GraveDeadDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="GravePosition" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GravePosition" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="GraveRow" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="GraveRow" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="GraveFloor" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="GraveFloor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="GraveNumber" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="GraveNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="GraveCustomerFK" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GraveCustomerFK" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT GraveID, GraveFirstName, GraveLastName, GraveBirthDate, GraveDeadDate, GravePosition, GraveRow, GraveFloor, GraveNumber, GraveCustomerFK FROM Graves</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Graves` SET `GraveFirstName` = ?, `GraveLastName` = ?, `GraveBirthDate` = ?, `GraveDeadDate` = ?, `GravePosition` = ?, `GraveRow` = ?, `GraveFloor` = ?, `GraveNumber` = ?, `GraveCustomerFK` = ? WHERE ((`GraveID` = ?) AND ((? = 1 AND `GraveFirstName` IS NULL) OR (`GraveFirstName` = ?)) AND ((? = 1 AND `GraveLastName` IS NULL) OR (`GraveLastName` = ?)) AND ((? = 1 AND `GraveBirthDate` IS NULL) OR (`GraveBirthDate` = ?)) AND ((? = 1 AND `GraveDeadDate` IS NULL) OR (`GraveDeadDate` = ?)) AND ((? = 1 AND `GravePosition` IS NULL) OR (`GravePosition` = ?)) AND ((? = 1 AND `GraveRow` IS NULL) OR (`GraveRow` = ?)) AND ((? = 1 AND `GraveFloor` IS NULL) OR (`GraveFloor` = ?)) AND ((? = 1 AND `GraveNumber` IS NULL) OR (`GraveNumber` = ?)) AND ((? = 1 AND `GraveCustomerFK` IS NULL) OR (`GraveCustomerFK` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="GraveFirstName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GraveFirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="GraveLastName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GraveLastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="GraveBirthDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="GraveBirthDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="GraveDeadDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="GraveDeadDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="GravePosition" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GravePosition" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="GraveRow" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="GraveRow" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="GraveFloor" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="GraveFloor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="GraveNumber" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="GraveNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="GraveCustomerFK" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GraveCustomerFK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_GraveID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GraveID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GraveFirstName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GraveFirstName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_GraveFirstName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GraveFirstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GraveLastName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GraveLastName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_GraveLastName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GraveLastName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GraveBirthDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GraveBirthDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_GraveBirthDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="GraveBirthDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GraveDeadDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GraveDeadDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_GraveDeadDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="GraveDeadDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GravePosition" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GravePosition" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_GravePosition" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GravePosition" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GraveRow" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GraveRow" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_GraveRow" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="GraveRow" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GraveFloor" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GraveFloor" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_GraveFloor" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="GraveFloor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GraveNumber" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GraveNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_GraveNumber" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="GraveNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GraveCustomerFK" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GraveCustomerFK" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_GraveCustomerFK" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GraveCustomerFK" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="GraveID" DataSetColumn="ID" />
              <Mapping SourceColumn="GraveFirstName" DataSetColumn="FirstName" />
              <Mapping SourceColumn="GraveLastName" DataSetColumn="LastName" />
              <Mapping SourceColumn="GraveBirthDate" DataSetColumn="BirthDate" />
              <Mapping SourceColumn="GraveDeadDate" DataSetColumn="DeadDate" />
              <Mapping SourceColumn="GravePosition" DataSetColumn="Position" />
              <Mapping SourceColumn="GraveRow" DataSetColumn="Row" />
              <Mapping SourceColumn="GraveFloor" DataSetColumn="Floor" />
              <Mapping SourceColumn="GraveNumber" DataSetColumn="Number" />
              <Mapping SourceColumn="GraveCustomerFK" DataSetColumn="CustomerFK" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PaymentsTableAdapter" GeneratorDataComponentClassName="PaymentsTableAdapter" Name="Payments" UserDataComponentName="PaymentsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="nrConnectionString (Settings)" DbObjectName="Payments" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Payments` WHERE ((`PaymentGraveFK` = ?) AND (`PaymentDate` = ?) AND ((? = 1 AND `PaymentAmount` IS NULL) OR (`PaymentAmount` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_PaymentGraveFK" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PaymentGraveFK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_PaymentDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="PaymentDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PaymentAmount" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PaymentAmount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_PaymentAmount" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="PaymentAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Payments` (`PaymentGraveFK`, `PaymentDate`, `PaymentAmount`) VALUES (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="PaymentGraveFK" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PaymentGraveFK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="PaymentDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="PaymentDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="PaymentAmount" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="PaymentAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT PaymentGraveFK, PaymentDate, PaymentAmount FROM Payments</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Payments` SET `PaymentGraveFK` = ?, `PaymentDate` = ?, `PaymentAmount` = ? WHERE ((`PaymentGraveFK` = ?) AND (`PaymentDate` = ?) AND ((? = 1 AND `PaymentAmount` IS NULL) OR (`PaymentAmount` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="PaymentGraveFK" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PaymentGraveFK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="PaymentDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="PaymentDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="PaymentAmount" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="PaymentAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_PaymentGraveFK" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PaymentGraveFK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_PaymentDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="PaymentDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PaymentAmount" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PaymentAmount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_PaymentAmount" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="PaymentAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PaymentGraveFK" DataSetColumn="GraveFK" />
              <Mapping SourceColumn="PaymentDate" DataSetColumn="PaymentDate" />
              <Mapping SourceColumn="PaymentAmount" DataSetColumn="PaymentAmount" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="nrDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="nrDataSet" msprop:Generator_UserDSName="nrDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Cities" msprop:Generator_TableClassName="CitiesDataTable" msprop:Generator_TableVarName="tableCities" msprop:Generator_RowChangedName="CitiesRowChanged" msprop:Generator_TablePropName="Cities" msprop:Generator_RowDeletingName="CitiesRowDeleting" msprop:Generator_RowChangingName="CitiesRowChanging" msprop:Generator_RowEvHandlerName="CitiesRowChangeEventHandler" msprop:Generator_RowDeletedName="CitiesRowDeleted" msprop:Generator_RowClassName="CitiesRow" msprop:Generator_UserTableName="Cities" msprop:Generator_RowEvArgName="CitiesRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ISTATCode" msprop:Generator_ColumnVarNameInTable="columnISTATCode" msprop:Generator_ColumnPropNameInRow="ISTATCode" msprop:Generator_ColumnPropNameInTable="ISTATCodeColumn" msprop:Generator_UserColumnName="ISTATCode" type="xs:int" minOccurs="0" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="District" msdata:Caption="CityDistrict" msprop:Generator_ColumnVarNameInTable="columnDistrict" msprop:Generator_ColumnPropNameInRow="District" msprop:Generator_ColumnPropNameInTable="DistrictColumn" msprop:Generator_UserColumnName="District" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Region" msdata:Caption="CityRegion" msprop:Generator_ColumnVarNameInTable="columnRegion" msprop:Generator_ColumnPropNameInRow="Region" msprop:Generator_ColumnPropNameInTable="RegionColumn" msprop:Generator_UserColumnName="Region" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PhoneAreaCode" msdata:Caption="CityPhoneAreaCode" msprop:Generator_ColumnVarNameInTable="columnPhoneAreaCode" msprop:Generator_ColumnPropNameInRow="PhoneAreaCode" msprop:Generator_ColumnPropNameInTable="PhoneAreaCodeColumn" msprop:Generator_UserColumnName="PhoneAreaCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ZIP" msdata:Caption="CityZIP" msprop:Generator_ColumnVarNameInTable="columnZIP" msprop:Generator_ColumnPropNameInRow="ZIP" msprop:Generator_ColumnPropNameInTable="ZIPColumn" msprop:Generator_UserColumnName="ZIP" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FiscalCode" msdata:Caption="CityFiscalCode" msprop:Generator_ColumnVarNameInTable="columnFiscalCode" msprop:Generator_ColumnPropNameInRow="FiscalCode" msprop:Generator_ColumnPropNameInTable="FiscalCodeColumn" msprop:Generator_UserColumnName="FiscalCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Peoples" msdata:Caption="CityPeoples" msprop:Generator_ColumnVarNameInTable="columnPeoples" msprop:Generator_ColumnPropNameInRow="Peoples" msprop:Generator_ColumnPropNameInTable="PeoplesColumn" msprop:Generator_UserColumnName="Peoples" type="xs:int" minOccurs="0" />
              <xs:element name="Link" msdata:Caption="CityLink" msprop:Generator_ColumnVarNameInTable="columnLink" msprop:Generator_ColumnPropNameInRow="Link" msprop:Generator_ColumnPropNameInTable="LinkColumn" msprop:Generator_UserColumnName="Link" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:Caption="CityID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="StateFK" msdata:Caption="CityState" msprop:Generator_ColumnVarNameInTable="columnStateFK" msprop:Generator_ColumnPropNameInRow="StateFK" msprop:Generator_ColumnPropNameInTable="StateFKColumn" msprop:Generator_UserColumnName="StateFK" type="xs:int" minOccurs="0" />
              <xs:element name="FullName" msdata:ReadOnly="true" msdata:Expression="Name + ' (' + District + ')'" msprop:Generator_ColumnVarNameInTable="columnFullName" msprop:Generator_ColumnPropNameInRow="FullName" msprop:Generator_ColumnPropNameInTable="FullNameColumn" msprop:Generator_UserColumnName="FullName" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="States" msprop:Generator_TableClassName="StatesDataTable" msprop:Generator_TableVarName="tableStates" msprop:Generator_RowChangedName="StatesRowChanged" msprop:Generator_TablePropName="States" msprop:Generator_RowDeletingName="StatesRowDeleting" msprop:Generator_RowChangingName="StatesRowChanging" msprop:Generator_RowEvHandlerName="StatesRowChangeEventHandler" msprop:Generator_RowDeletedName="StatesRowDeleted" msprop:Generator_RowClassName="StatesRow" msprop:Generator_UserTableName="States" msprop:Generator_RowEvArgName="StatesRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Name" msdata:Caption="StateName" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FiscalCode" msprop:Generator_ColumnVarNameInTable="columnFiscalCode" msprop:Generator_ColumnPropNameInRow="FiscalCode" msprop:Generator_ColumnPropNameInTable="FiscalCodeColumn" msprop:Generator_UserColumnName="FiscalCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ISTATCode" msdata:Caption="StateIstatCode" msprop:Generator_ColumnVarNameInTable="columnISTATCode" msprop:Generator_ColumnPropNameInRow="ISTATCode" msprop:Generator_ColumnPropNameInTable="ISTATCodeColumn" msprop:Generator_UserColumnName="ISTATCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:Caption="StateID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Customers" msprop:Generator_TableClassName="CustomersDataTable" msprop:Generator_TableVarName="tableCustomers" msprop:Generator_RowChangedName="CustomersRowChanged" msprop:Generator_TablePropName="Customers" msprop:Generator_RowDeletingName="CustomersRowDeleting" msprop:Generator_RowChangingName="CustomersRowChanging" msprop:Generator_RowEvHandlerName="CustomersRowChangeEventHandler" msprop:Generator_RowDeletedName="CustomersRowDeleted" msprop:Generator_RowClassName="CustomersRow" msprop:Generator_UserTableName="Customers" msprop:Generator_RowEvArgName="CustomersRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:Caption="CustomerID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="FirstName" msdata:Caption="CustomerFirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn" msprop:Generator_UserColumnName="FirstName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastName" msdata:Caption="CustomerLastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn" msprop:Generator_UserColumnName="LastName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MainAddress" msdata:Caption="CustomerMainAddress" msprop:Generator_ColumnVarNameInTable="columnMainAddress" msprop:Generator_ColumnPropNameInRow="MainAddress" msprop:Generator_ColumnPropNameInTable="MainAddressColumn" msprop:Generator_UserColumnName="MainAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MainCity" msdata:Caption="CustomerMainCity" msprop:Generator_ColumnVarNameInTable="columnMainCity" msprop:Generator_ColumnPropNameInRow="MainCity" msprop:Generator_ColumnPropNameInTable="MainCityColumn" msprop:Generator_UserColumnName="MainCity" type="xs:int" default="7110" minOccurs="0" />
              <xs:element name="Lamps" msdata:Caption="CustomerLamps" msprop:Generator_ColumnVarNameInTable="columnLamps" msprop:Generator_ColumnPropNameInRow="Lamps" msprop:Generator_ColumnPropNameInTable="LampsColumn" msprop:Generator_UserColumnName="Lamps" type="xs:unsignedByte" default="1" minOccurs="0" />
              <xs:element name="LampPrice" msdata:Caption="CustomerLampPrice" msprop:Generator_ColumnVarNameInTable="columnLampPrice" msprop:Generator_ColumnPropNameInRow="LampPrice" msprop:Generator_ColumnPropNameInTable="LampPriceColumn" msprop:Generator_UserColumnName="LampPrice" type="xs:decimal" default="15" minOccurs="0" />
              <xs:element name="FullName" msdata:ReadOnly="true" msdata:Expression="LastName + ' ' + FirstName" msprop:Generator_ColumnVarNameInTable="columnFullName" msprop:Generator_ColumnPropNameInRow="FullName" msprop:Generator_ColumnPropNameInTable="FullNameColumn" msprop:Generator_UserColumnName="FullName" type="xs:string" minOccurs="0" />
              <xs:element name="CityName" msdata:ReadOnly="true" msdata:Expression="Parent(CitiesCustomers).FullName" msprop:Generator_ColumnVarNameInTable="columnCityName" msprop:Generator_ColumnPropNameInRow="CityName" msprop:Generator_ColumnPropNameInTable="CityNameColumn" msprop:Generator_UserColumnName="CityName" type="xs:string" minOccurs="0" />
              <xs:element name="PaymentAmount" msdata:ReadOnly="true" msdata:Expression="Lamps * LampPrice" msprop:Generator_ColumnVarNameInTable="columnPaymentAmount" msprop:Generator_ColumnPropNameInRow="PaymentAmount" msprop:Generator_ColumnPropNameInTable="PaymentAmountColumn" msprop:Generator_UserColumnName="PaymentAmount" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Graves" msprop:Generator_TableClassName="GravesDataTable" msprop:Generator_TableVarName="tableGraves" msprop:Generator_RowChangedName="GravesRowChanged" msprop:Generator_TablePropName="Graves" msprop:Generator_RowDeletingName="GravesRowDeleting" msprop:Generator_RowChangingName="GravesRowChanging" msprop:Generator_RowEvHandlerName="GravesRowChangeEventHandler" msprop:Generator_RowDeletedName="GravesRowDeleted" msprop:Generator_RowClassName="GravesRow" msprop:Generator_UserTableName="Graves" msprop:Generator_RowEvArgName="GravesRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:Caption="GraveID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="FirstName" msdata:Caption="GraveFirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn" msprop:Generator_UserColumnName="FirstName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastName" msdata:Caption="GraveLastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn" msprop:Generator_UserColumnName="LastName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BirthDate" msdata:Caption="GraveBirthDate" msprop:Generator_ColumnVarNameInTable="columnBirthDate" msprop:Generator_ColumnPropNameInRow="BirthDate" msprop:Generator_ColumnPropNameInTable="BirthDateColumn" msprop:Generator_UserColumnName="BirthDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DeadDate" msdata:Caption="GraveDeadDate" msprop:Generator_ColumnVarNameInTable="columnDeadDate" msprop:Generator_ColumnPropNameInRow="DeadDate" msprop:Generator_ColumnPropNameInTable="DeadDateColumn" msprop:Generator_UserColumnName="DeadDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Position" msdata:Caption="GravePosition" msprop:Generator_ColumnVarNameInTable="columnPosition" msprop:Generator_ColumnPropNameInRow="Position" msprop:Generator_ColumnPropNameInTable="PositionColumn" msprop:Generator_UserColumnName="Position" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Row" msdata:Caption="GraveRow" msprop:Generator_ColumnVarNameInTable="columnRow" msprop:Generator_ColumnPropNameInRow="Row" msprop:Generator_ColumnPropNameInTable="RowColumn" msprop:Generator_UserColumnName="Row" type="xs:short" minOccurs="0" />
              <xs:element name="Floor" msdata:Caption="GraveFloor" msprop:Generator_ColumnVarNameInTable="columnFloor" msprop:Generator_ColumnPropNameInRow="Floor" msprop:Generator_ColumnPropNameInTable="FloorColumn" msprop:Generator_UserColumnName="Floor" type="xs:short" minOccurs="0" />
              <xs:element name="Number" msdata:Caption="GraveNumber" msprop:Generator_ColumnVarNameInTable="columnNumber" msprop:Generator_ColumnPropNameInRow="Number" msprop:Generator_ColumnPropNameInTable="NumberColumn" msprop:Generator_UserColumnName="Number" type="xs:short" minOccurs="0" />
              <xs:element name="CustomerFK" msdata:Caption="GraveCustomerFK" msprop:Generator_ColumnVarNameInTable="columnCustomerFK" msprop:Generator_ColumnPropNameInRow="CustomerFK" msprop:Generator_ColumnPropNameInTable="CustomerFKColumn" msprop:Generator_UserColumnName="CustomerFK" type="xs:int" minOccurs="0" />
              <xs:element name="GraveFullName" msdata:ReadOnly="true" msdata:Expression="LastName + ' ' + FirstName + ' (N. ' + BirthDate + ' - M. ' + DeadDate + ')'" msprop:Generator_ColumnVarNameInTable="columnGraveFullName" msprop:Generator_ColumnPropNameInRow="GraveFullName" msprop:Generator_ColumnPropNameInTable="GraveFullNameColumn" msprop:Generator_UserColumnName="GraveFullName" type="xs:string" minOccurs="0" />
              <xs:element name="CustomerFullName" msdata:ReadOnly="true" msdata:Expression="Parent(CustomersGraves).FullName" msprop:Generator_ColumnVarNameInTable="columnCustomerFullName" msprop:Generator_ColumnPropNameInRow="CustomerFullName" msprop:Generator_ColumnPropNameInTable="CustomerFullNameColumn" msprop:Generator_UserColumnName="CustomerFullName" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Payments" msprop:Generator_TableClassName="PaymentsDataTable" msprop:Generator_TableVarName="tablePayments" msprop:Generator_RowChangedName="PaymentsRowChanged" msprop:Generator_TablePropName="Payments" msprop:Generator_RowDeletingName="PaymentsRowDeleting" msprop:Generator_RowChangingName="PaymentsRowChanging" msprop:Generator_RowEvHandlerName="PaymentsRowChangeEventHandler" msprop:Generator_RowDeletedName="PaymentsRowDeleted" msprop:Generator_RowClassName="PaymentsRow" msprop:Generator_UserTableName="Payments" msprop:Generator_RowEvArgName="PaymentsRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="GraveFK" msdata:Caption="PaymentGraveFK" msprop:Generator_ColumnVarNameInTable="columnGraveFK" msprop:Generator_ColumnPropNameInRow="GraveFK" msprop:Generator_ColumnPropNameInTable="GraveFKColumn" msprop:Generator_UserColumnName="GraveFK" type="xs:int" />
              <xs:element name="PaymentDate" msprop:Generator_ColumnVarNameInTable="columnPaymentDate" msprop:Generator_ColumnPropNameInRow="PaymentDate" msprop:Generator_ColumnPropNameInTable="PaymentDateColumn" msprop:Generator_UserColumnName="PaymentDate" type="xs:dateTime" />
              <xs:element name="PaymentAmount" msprop:Generator_ColumnVarNameInTable="columnPaymentAmount" msprop:Generator_ColumnPropNameInRow="PaymentAmount" msprop:Generator_ColumnPropNameInTable="PaymentAmountColumn" msprop:Generator_UserColumnName="PaymentAmount" type="xs:decimal" minOccurs="0" />
              <xs:element name="GraveFullName" msdata:ReadOnly="true" msdata:Expression="Parent(GravesPayments).GraveFullName" msprop:Generator_ColumnVarNameInTable="columnGraveFullName" msprop:Generator_ColumnPropNameInRow="GraveFullName" msprop:Generator_ColumnPropNameInTable="GraveFullNameColumn" msprop:Generator_UserColumnName="GraveFullName" type="xs:string" minOccurs="0" />
              <xs:element name="CustomerFullName" msdata:ReadOnly="true" msdata:Expression="Parent(GravesPayments).CustomerFullName" msprop:Generator_ColumnVarNameInTable="columnCustomerFullName" msprop:Generator_ColumnPropNameInRow="CustomerFullName" msprop:Generator_ColumnPropNameInTable="CustomerFullNameColumn" msprop:Generator_UserColumnName="CustomerFullName" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Cities" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="States_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:States" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Customers_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Customers" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Graves_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Graves" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Payments_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Payments" />
      <xs:field xpath="mstns:GraveFK" />
      <xs:field xpath="mstns:PaymentDate" />
    </xs:unique>
    <xs:keyref name="GravesPayments" refer="Graves_Constraint1" msprop:rel_Generator_UserChildTable="Payments" msprop:rel_Generator_ChildPropName="GetPaymentsRows" msprop:rel_Generator_UserRelationName="GravesPayments" msprop:rel_Generator_ParentPropName="GravesRow" msprop:rel_Generator_RelationVarName="relationGravesPayments" msprop:rel_Generator_UserParentTable="Graves" msdata:AcceptRejectRule="Cascade">
      <xs:selector xpath=".//mstns:Payments" />
      <xs:field xpath="mstns:GraveFK" />
    </xs:keyref>
    <xs:keyref name="CustomersGraves" refer="Customers_Constraint1" msprop:rel_Generator_UserChildTable="Graves" msprop:rel_Generator_ChildPropName="GetGravesRows" msprop:rel_Generator_UserRelationName="CustomersGraves" msprop:rel_Generator_ParentPropName="CustomersRow" msprop:rel_Generator_RelationVarName="relationCustomersGraves" msprop:rel_Generator_UserParentTable="Customers" msdata:AcceptRejectRule="Cascade">
      <xs:selector xpath=".//mstns:Graves" />
      <xs:field xpath="mstns:CustomerFK" />
    </xs:keyref>
    <xs:keyref name="CitiesCustomers" refer="Constraint1" msprop:rel_Generator_UserChildTable="Customers" msprop:rel_Generator_ChildPropName="GetCustomersRows" msprop:rel_Generator_UserRelationName="CitiesCustomers" msprop:rel_Generator_ParentPropName="CitiesRow" msprop:rel_Generator_RelationVarName="relationCitiesCustomers" msprop:rel_Generator_UserParentTable="Cities" msdata:AcceptRejectRule="Cascade">
      <xs:selector xpath=".//mstns:Customers" />
      <xs:field xpath="mstns:MainCity" />
    </xs:keyref>
    <xs:keyref name="StatesCities" refer="States_Constraint1" msprop:rel_Generator_UserChildTable="Cities" msprop:rel_Generator_ChildPropName="GetCitiesRows" msprop:rel_Generator_UserRelationName="StatesCities" msprop:rel_Generator_RelationVarName="relationStatesCities" msprop:rel_Generator_UserParentTable="States" msprop:rel_Generator_ParentPropName="StatesRow" msdata:AcceptRejectRule="Cascade">
      <xs:selector xpath=".//mstns:Cities" />
      <xs:field xpath="mstns:StateFK" />
    </xs:keyref>
  </xs:element>
</xs:schema>